﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SS2TC.Main
{
    /// <summary>
    /// Utility class with database connection strings.
    /// </summary>
    static class DatabaseStrings
    {
        /// <summary>
        /// Gets the connection string to Speech database.
        /// </summary>
        internal static string SpeechDatabaseConnection
        {
            get { return @"Data Source=JUNGLE\SQLEXPRESS; database=Speech; Integrated Security=SSPI;"; }
        }

        /// <summary>
        /// Gets the query to insert into Vowel table.
        /// </summary>
        internal static string InsertToVowel
        {
            get { return @"INSERT INTO Vowel (Letter, SampleData) VALUES (@Letter, @SampleData)"; }
        }

        /// <summary>
        /// Gets the query to insert into Vowel table.
        /// </summary>
        internal static string UpdateLetterInVowel
        {
            get { return @"UPDATE Vowel SET Letter = @Letter WHERE Letter='අ'"; }
        }

        /// <summary>
        /// Gets the query to insert into Vowel table.
        /// </summary>
        internal static string SelectAllFromVowel
        {
            get { return @"SELECT * FROM dbo.Vowel"; }
        }
    }
}
